package messagecontroller;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

public interface ClassMapper {
	
	@Select("select * from message where username = #{username}")
	public Message getUser(String username);
	
	@Update("update message set name = #{name} where username = #{username}")
	public void updatename(@Param("name")String name,@Param("username") String username);
	
	@Update("update message set email = #{email} where username = #{username}")
	public void updateemail(@Param("email")String email,@Param("username") String username);
	
	@Update("update message set phone = #{phone} where username = #{username}")
	public void updatephone(@Param("phone")String phone,@Param("username") String username);
	
	@Update("update message set qq = #{qq} where username = #{username}")
	public void updateqq(@Param("qq")String qq,@Param("username") String username);
	}
